Skip to main content

Web Common issues

Issue #1​

If contact list showing Loading and not giving anything or error "ONLY_FULL_GROUP_BY"

Solution:​

  • Run following command in MySQL.

     sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

  • Add the sql_mode Line:

    [mysqld]
    sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"

  • Restart the mysql

     sudo systemctl restart mysql